How Many Deaths Per State?

By: Meghan O'Malley

Read the Data

We are using pandas to read a csv file from the CDC.

Inspecting the Data

We want to be looking at the states. By doing this we are considering the unique values.

Cleaning

As shown above, New York City was in the list and so was the United States. Because these are not states we will take them out.

Table of All Deaths Per State

Visualizations

Death count by state starting in 2020. Although there are many lines we can still notice patterns in the trend lines. This is important because this graph can be compared to other years and we can see how the trends compare.

Because 2021 has just started there is data here. But I would just like to look at 2020...

As shown above, each state has a differnt number of deaths. The bar chart is a nice way to understand that each state varries. This can we expanded by looking at other factors as well including the states population. And all this information can be compared to any COVID-19 information.

Continuing, I wanted to look at the region where I currently live. Colorado by far has had the most amount of people die in 2020, but not all states are created equal. Population is forsure a factor. This makes me wonder the difference in population amoung Utah and New Mexico. I would guess that they are pretty close based on the following graph.

Covid-19 has made 2020 a historic year. This graph allows us to evaluate 'out of all deaths how many of those were COVID?'.

Now I wanted to evaluate the two states that I live in. I can learn from the graph that Illinois has more weekly deaths than Colorado. In fact, the lowest number of deaths in Illinois is still more than the highest reported week in Colorado.

Overall, I learned more about the number of deaths in America by looking at these graphs.